Python Job: SQL Developer

Welcome to This Australian Life.

From the millions of Australians we protect, to those that make it happen every day at TAL, people really are what we’re all about. We want to grow with you. Achieve with you. And support you to do your best work. That's why we're focused on developing leadership, promoting diversity, rewarding excellence and retaining great talent.

We're always looking for people who want to go further with us. People who do what’s right, aim high, and work smart. Why not see where we can go?

Please note this is a 12-month fixed term contract role.

Your responsibilities will include:

ETL of Prophet Results

• Demonstrate an understanding of the working of the FIS ETL tools
• Design a database structure for storage of financial forecasting results
• Implement the design in Microsoft SQL Server
• Implement parameters for ETL processes that allow for data to be moved from FIS Prophet into the forecasting database.

Implementation of Euler Capital Allocation

• Develop capability for forecasting database to implement the Euler capital allocation method based on the specification provided by the actuarial team

Provision of Results for Downstream Consumption

• Provide data views and/or file extracts of financial forecasting results and Euler capital allocations as specified by other members of the project team.

Coding Environment

• Perform and document system testing activities (unit testing, end to end testing, etc.)
• Deploy solutions from Development to Pre-Prod and Prod environments
• Ensure quality of code and adherence to platform frameworks and guidelines through code reviews and peer education.

Essential:

• Strong SQL knowledge and development experience
• Experience with design and developing data reconciliation & metadata driven data processing frameworks.
• Cleansing, manipulating or joining large volumes of data to facilitate analytics
• Working knowledge of Excel.
• Experience in building real time or batch ingestion and transformation pipelines.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• Experience working in the Financial Service Industry

Desirable:

• SQL Database design experience.
• Broad knowledge of application development tools, techniques and languages including C#, ASP.NET, T-SQL, IIS, Bootstrap, JQuery, Azure DevOps, GIT, Python, R, XML, JavaScript, HTML, CSS
• At least 3 years of professional work experience
• Experience with Atlassian software workflow and documentation tools – JIRA and Confluence
• Good communication skills
• Exposure to FIS insurance suite of products – Prophet

Work is a big part of this Australian life, and we work hard to make it one of the best parts. We don’t just say it; we do it. We offer a workplace that’s inclusive and flexible, supporting our people with options that let them make the most of their careers.

We know the value of having different people from all walks of life, with varied points of view and attributes regardless of their age, ethnicity, religion, sexual orientation, gender identity, intersex status or any disabilities they might be living with. We strive for a diverse and inclusive workplace where a sense of belonging encourages people to bring their full selves to work.

#LI-Hybrid

Everyone at TAL has a responsibility to do the right thing and is accountable for the way they conduct themselves. Our expectations are that you follow the principles set out in our Code of Conduct when you come to work every day. Risk management is everyone’s responsibility.

If you are already a TAL employee please apply via the SmartRecruiters button in Workday and navigate to the Employee Portal. This is important to ensure that your application is recorded accurately.